IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_sp_ContentSelectOne]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[cms_sp_ContentSelectOne]
GO

create procedure [dbo].[cms_sp_ContentSelectOne]
(
	@Id int
)
as

select 
	ContentId as Id,
	PublicContentId,
	SiteId,
	SiteGroupId,
	SystemLanguageId,
	ContentTypeId,
	ContentTitle,
	ContentSummary,
	ContentBody,
	ContentCode,
	CreatedBy,
	DateCreated,
	LastUpdatedBy,
	DateLastUpdated
from Contents
where ContentId = @Id


GO


